package com.wanbangee.marksystem.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.wanbangee.marksystem.entities.UGrade;
import com.wanbangee.marksystem.entities.UGradeSubjectRelation;
import com.wanbangee.marksystem.entities.USubject;
@Mapper
public interface UGradeSubjectRelationDao {
	/**
	 * 根据学校与年级id查询学科
	 * @param schId
	 * @param subId
	 * @return
	 */
	public List<UGradeSubjectRelation> selectSubjectBygraId(int schId, int graId);
	/**
	 * 根据传入的list集合学科年纪关系表插入到年级中
	 * @param url
	 * @return
	 */
	public int insertSubjectIntoGrade(UGradeSubjectRelation ugr);
	/**
	 * 更改学科-----先删
	 * @param ugr
	 * @return
	 */
	public int deleteSubjectFromGrade(int graId,int schId);
	/**
	 * 根据学校id查询年级
	 * @param schId
	 * @return
	 */
	public List<UGrade> selectGradeBySchId(int schId);
}
